<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_delivery_order`;");
E_C("CREATE TABLE `ecs_delivery_order` (
  `delivery_id` mediumint(8) unsigned NOT NULL auto_increment,
  `delivery_sn` varchar(20) NOT NULL,
  `order_sn` varchar(20) NOT NULL,
  `order_id` mediumint(8) unsigned NOT NULL default '0',
  `invoice_no` varchar(50) default NULL,
  `add_time` int(10) unsigned default '0',
  `shipping_id` tinyint(3) unsigned default '0',
  `shipping_name` varchar(120) default NULL,
  `user_id` mediumint(8) unsigned default '0',
  `action_user` varchar(30) default NULL,
  `consignee` varchar(60) default NULL,
  `address` varchar(250) default NULL,
  `country` smallint(5) unsigned default '0',
  `province` smallint(5) unsigned default '0',
  `city` smallint(5) unsigned default '0',
  `district` smallint(5) unsigned default '0',
  `sign_building` varchar(120) default NULL,
  `email` varchar(60) default NULL,
  `zipcode` varchar(60) default NULL,
  `tel` varchar(60) default NULL,
  `mobile` varchar(60) default NULL,
  `best_time` varchar(120) default NULL,
  `postscript` varchar(255) default NULL,
  `how_oos` varchar(120) default NULL,
  `insure_fee` decimal(10,2) unsigned default '0.00',
  `shipping_fee` decimal(10,2) unsigned default '0.00',
  `update_time` int(10) unsigned default '0',
  `suppliers_id` smallint(5) default '0',
  `status` tinyint(1) unsigned NOT NULL default '0',
  `agency_id` smallint(5) unsigned default '0',
  PRIMARY KEY  (`delivery_id`),
  KEY `user_id` (`user_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_delivery_order` values('1','20131209012778161','2013120473345','1','','1386147410','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386552449','0','0','0');");
E_D("replace into `ecs_delivery_order` values('2','20131209014413992','2013120949445','2','','1386552801','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386553448','0','0','0');");
E_D("replace into `ecs_delivery_order` values('3','20131209014649976','2013120908089','3','','1386553434','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386553582','0','0','0');");
E_D("replace into `ecs_delivery_order` values('4','20131209014974054','2013120988111','4','','1386553768','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386553776','0','0','0');");
E_D("replace into `ecs_delivery_order` values('5','20131209015024263','2013120996745','5','','1386553815','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386553825','0','0','0');");
E_D("replace into `ecs_delivery_order` values('6','20131209023479474','2013120965241','6','','1386553894','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386556497','0','0','0');");
E_D("replace into `ecs_delivery_order` values('7','20131209024122038','2013120924021','7','','1386556843','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386556866','0','0','0');");
E_D("replace into `ecs_delivery_order` values('8','20131209024572336','2013120902196','8','','1386557124','5','申通快递','6','admin','111','222','1','2','52','502','','497110669@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1386557140','0','0','0');");
E_D("replace into `ecs_delivery_order` values('9','20131216081367776','2013121684768','9','','1387181172','5','申通快递','0','admin','111111111','222','1','6','82','759','','444@qq.com','','33','','','','等待所有商品备齐后再发','0.00','15.00','1387181628','0','0','0');");
E_D("replace into `ecs_delivery_order` values('10','20131216082420864','2013121657464','10','','1387182222','5','申通快递','0','admin','111','222','1','6','79','717','','444@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1387182253','0','0','0');");
E_D("replace into `ecs_delivery_order` values('11','20131216083184742','2013121645168','11','','1387182695','5','申通快递','0','admin','1','2','1','5','65','626','','4@qq.com','','3','','','','等待所有商品备齐后再发','0.00','15.00','1387182711','0','0','0');");
E_D("replace into `ecs_delivery_order` values('12','20131216083440457','2013121656803','12','','1387182847','5','申通快递','0','admin','11','22','1','5','65','626','','55@qq.com','','33','','','','等待所有商品备齐后再发','0.00','15.00','1387182865','0','0','0');");
E_D("replace into `ecs_delivery_order` values('13','20131216083676537','2013121607394','13','','1387182982','5','申通快递','0','admin','11','22','1','6','80','749','','55@qq.com','','33','','','','等待所有商品备齐后再发','0.00','15.00','1387182997','0','0','0');");
E_D("replace into `ecs_delivery_order` values('14','20131216083861095','2013121640047','14','','1387183088','5','申通快递','0','admin','111','222','1','10','143','1175','','666@qq.com','','333','','','','等待所有商品备齐后再发','0.00','15.00','1387183102','0','0','0');");
E_D("replace into `ecs_delivery_order` values('15','20141217100172525','2014121764824','28','','1418752865','5','申通快递','0','admin','11111111111','1111111111111','1','6','80','749','','11111@qq.com','','1111111','','','','等待所有商品备齐后再发','0.00','15.00','1418752911','0','0','0');");
E_D("replace into `ecs_delivery_order` values('16','20151031180303455','2015103145914','61','','1446256977','8','顺丰速运','15','admin','小蜂','光明大道千栩大厦','1','6','79','715','','782869779@qq.com','','15916852053','15916852053','','','等待所有商品备齐后再发','0.00','15.00','1446256990','0','0','0');");

require("../../inc/footer.php");
?>